Overview

Dataset statistics

Number of variables18
Number of observations1316
Missing cells2069
Missing cells (%)8.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory195.3 KiB
Average record size in memory152.0 B

Variable types

DateTime1
Numeric17

Alerts

ta is highly overall correlated with par and 7 other fieldsHigh correlation
press is highly overall correlated with So and 1 other fieldsHigh correlation
par is highly overall correlated with ta and 5 other fieldsHigh correlation
Rn is highly overall correlated with ta and 6 other fieldsHigh correlation
H is highly overall correlated with ta and 4 other fieldsHigh correlation
LE is highly overall correlated with ta and 5 other fieldsHigh correlation
rh is highly overall correlated with ta and 7 other fieldsHigh correlation
h2o is highly overall correlated with rh and 1 other fieldsHigh correlation
ees is highly overall correlated with ta and 5 other fieldsHigh correlation
So is highly overall correlated with press and 2 other fieldsHigh correlation
prec is highly overall correlated with ta and 1 other fieldsHigh correlation
LAI is highly overall correlated with press and 2 other fieldsHigh correlation
ee is highly overall correlated with rh and 1 other fieldsHigh correlation
NEE is highly overall correlated with ta and 1 other fieldsHigh correlation
aod is highly overall correlated with So and 1 other fieldsHigh correlation
ta has 135 (10.3%) missing valuesMissing
press has 28 (2.1%) missing valuesMissing
Rn has 325 (24.7%) missing valuesMissing
ws has 132 (10.0%) missing valuesMissing
H has 149 (11.3%) missing valuesMissing
LE has 282 (21.4%) missing valuesMissing
rh has 261 (19.8%) missing valuesMissing
h2o has 235 (17.9%) missing valuesMissing
Fh2o has 201 (15.3%) missing valuesMissing
ee has 279 (21.2%) missing valuesMissing
ees has 19 (1.4%) missing valuesMissing
aod has 15 (1.1%) missing valuesMissing
Date has unique valuesUnique
prec has 710 (54.0%) zerosZeros

Reproduction

Analysis started2022-12-07 14:48:41.151372
Analysis finished2022-12-07 14:49:32.350890
Duration51.2 seconds
Software versionpandas-profiling vv3.5.0
Download configurationconfig.json

Variables

Date
Date

Distinct1316
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size20.6 KiB
Minimum2001-12-31 00:00:00
Maximum2005-12-31 00:00:00
Histogram with fixed size bins (bins=50)

ta
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct1179
Distinct (%)99.8%
Missing135
Missing (%)10.3%
Infinite0
Infinite (%)0.0%
Mean25.277286
Minimum21.788875
Maximum27.971125
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum21.788875
5-th percentile23.323522
Q124.45175
median25.335542
Q326.148375
95-th percentile26.965542
Maximum27.971125
Range6.18225
Interquartile range (IQR)1.696625

Descriptive statistics

Standard deviation1.1271465
Coefficient of variation (CV)0.044591279
Kurtosis-0.46869674
Mean25.277286
Median Absolute Deviation (MAD)0.8495
Skewness-0.28674427
Sum29852.475
Variance1.2704593
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
23.664875 2
 
0.2%
24.2825 2
 
0.2%
25.16041667 1
 
0.1%
26.02704167 1
 
0.1%
24.89316667 1
 
0.1%
25.60920833 1
 
0.1%
24.466125 1
 
0.1%
24.94352083 1
 
0.1%
24.61004167 1
 
0.1%
23.53408333 1
 
0.1%
Other values (1169) 1169
88.8%
(Missing) 135
 
10.3%
ValueCountFrequency (%)
21.788875 1
0.1%
21.82395833 1
0.1%
21.97625 1
0.1%
22.12975 1
0.1%
22.200375 1
0.1%
22.27195833 1
0.1%
22.30220833 1
0.1%
22.31170833 1
0.1%
22.32975 1
0.1%
22.38191304 1
0.1%
ValueCountFrequency (%)
27.971125 1
0.1%
27.67154167 1
0.1%
27.62 1
0.1%
27.59870833 1
0.1%
27.5545 1
0.1%
27.50883333 1
0.1%
27.50654167 1
0.1%
27.34690909 1
0.1%
27.340125 1
0.1%
27.30208333 1
0.1%

press
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct1280
Distinct (%)99.4%
Missing28
Missing (%)2.1%
Infinite0
Infinite (%)0.0%
Mean97.514037
Minimum96.915783
Maximum98.016325
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum96.915783
5-th percentile97.173023
Q197.374977
median97.514431
Q397.669935
95-th percentile97.824101
Maximum98.016325
Range1.1005417
Interquartile range (IQR)0.29495833

Descriptive statistics

Standard deviation0.20482885
Coefficient of variation (CV)0.0021005063
Kurtosis-0.39693697
Mean97.514037
Median Absolute Deviation (MAD)0.14937083
Skewness-0.2146704
Sum125598.08
Variance0.041954857
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
97.37682917 6
 
0.5%
97.48195833 2
 
0.2%
97.38665 2
 
0.2%
97.40247391 2
 
0.2%
97.57980417 1
 
0.1%
97.49940833 1
 
0.1%
97.61938333 1
 
0.1%
97.68883333 1
 
0.1%
97.7934625 1
 
0.1%
97.63882917 1
 
0.1%
Other values (1270) 1270
96.5%
(Missing) 28
 
2.1%
ValueCountFrequency (%)
96.91578333 1
0.1%
96.93217083 1
0.1%
96.9344375 1
0.1%
96.94302917 1
0.1%
96.95365 1
0.1%
96.96357083 1
0.1%
96.96418333 1
0.1%
96.9758125 1
0.1%
96.99268333 1
0.1%
96.99402083 1
0.1%
ValueCountFrequency (%)
98.016325 1
0.1%
98.0029 1
0.1%
98.00215833 1
0.1%
97.985475 1
0.1%
97.97918333 1
0.1%
97.95863333 1
0.1%
97.950425 1
0.1%
97.94232917 1
0.1%
97.94067083 1
0.1%
97.93676667 1
0.1%

par
Real number (ℝ)

Distinct1274
Distinct (%)97.1%
Missing4
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean345.42192
Minimum93.692417
Maximum559.05546
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum93.692417
5-th percentile196.54793
Q1303.27688
median353.49371
Q3399.74271
95-th percentile454.98964
Maximum559.05546
Range465.36304
Interquartile range (IQR)96.465833

Descriptive statistics

Standard deviation78.367192
Coefficient of variation (CV)0.22687382
Kurtosis0.312296
Mean345.42192
Median Absolute Deviation (MAD)48.621854
Skewness-0.52155905
Sum453193.56
Variance6141.4168
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
214.2139167 2
 
0.2%
423.473375 2
 
0.2%
337.3300417 2
 
0.2%
422.902875 2
 
0.2%
322.1424167 2
 
0.2%
438.0894167 2
 
0.2%
356.8924167 2
 
0.2%
402.28075 2
 
0.2%
386.991875 2
 
0.2%
304.7550833 2
 
0.2%
Other values (1264) 1292
98.2%
(Missing) 4
 
0.3%
ValueCountFrequency (%)
93.69241667 1
0.1%
98.69016667 1
0.1%
102.0448333 1
0.1%
102.1322083 1
0.1%
107.0464167 1
0.1%
109.115 1
0.1%
114.7097083 1
0.1%
115.1677083 1
0.1%
116.1137917 1
0.1%
117.3541667 1
0.1%
ValueCountFrequency (%)
559.0554583 1
0.1%
552.9184167 1
0.1%
540.8067917 1
0.1%
539.9113333 1
0.1%
536.6390833 1
0.1%
535.2705833 1
0.1%
534.4649583 1
0.1%
527.55175 1
0.1%
522.96325 1
0.1%
514.3583333 1
0.1%

Rn
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct987
Distinct (%)99.6%
Missing325
Missing (%)24.7%
Infinite0
Infinite (%)0.0%
Mean134.42857
Minimum32.825
Maximum209.97292
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum32.825
5-th percentile74.35625
Q1116.4349
median138.90833
Q3156.61042
95-th percentile179.41979
Maximum209.97292
Range177.14792
Interquartile range (IQR)40.175521

Descriptive statistics

Standard deviation32.093374
Coefficient of variation (CV)0.23873923
Kurtosis0.26779205
Mean134.42857
Median Absolute Deviation (MAD)19.858333
Skewness-0.66242514
Sum133218.72
Variance1029.9847
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
154.9260417 2
 
0.2%
132.315625 2
 
0.2%
138.9083333 2
 
0.2%
164.9604167 2
 
0.2%
129.9104167 1
 
0.1%
137.484375 1
 
0.1%
149.1208333 1
 
0.1%
61.20833333 1
 
0.1%
151.56875 1
 
0.1%
144.7354167 1
 
0.1%
Other values (977) 977
74.2%
(Missing) 325
 
24.7%
ValueCountFrequency (%)
32.825 1
0.1%
33.1375 1
0.1%
34.41041667 1
0.1%
37.4 1
0.1%
38.30681818 1
0.1%
39.30625 1
0.1%
41.49791667 1
0.1%
41.51875 1
0.1%
42.86666667 1
0.1%
44.99791667 1
0.1%
ValueCountFrequency (%)
209.9729167 1
0.1%
208.06875 1
0.1%
204.1864583 1
0.1%
202.825 1
0.1%
201.325 1
0.1%
197.9666667 1
0.1%
197.7458333 1
0.1%
195.9083333 1
0.1%
194.26875 1
0.1%
192.409375 1
0.1%

ws
Real number (ℝ)

Distinct1178
Distinct (%)99.5%
Missing132
Missing (%)10.0%
Infinite0
Infinite (%)0.0%
Mean2.6715079
Minimum0.89010417
Maximum4.2766875
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum0.89010417
5-th percentile1.6555042
Q12.2942396
median2.7321042
Q33.0733438
95-th percentile3.495575
Maximum4.2766875
Range3.3865833
Interquartile range (IQR)0.77910417

Descriptive statistics

Standard deviation0.5646761
Coefficient of variation (CV)0.21136981
Kurtosis-0.0056414243
Mean2.6715079
Median Absolute Deviation (MAD)0.3834989
Skewness-0.46238125
Sum3163.0653
Variance0.3188591
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3.033166667 2
 
0.2%
3.004125 2
 
0.2%
2.155208333 2
 
0.2%
3.15775 2
 
0.2%
3.03675 2
 
0.2%
3.366333333 2
 
0.2%
2.571184304 1
 
0.1%
2.934666667 1
 
0.1%
2.45973047 1
 
0.1%
2.366833333 1
 
0.1%
Other values (1168) 1168
88.8%
(Missing) 132
 
10.0%
ValueCountFrequency (%)
0.8901041667 1
0.1%
0.891375 1
0.1%
0.9578333333 1
0.1%
0.9636666667 1
0.1%
0.9689708986 1
0.1%
0.9693125 1
0.1%
1.094833333 1
0.1%
1.115062176 1
0.1%
1.134895833 1
0.1%
1.13975 1
0.1%
ValueCountFrequency (%)
4.2766875 1
0.1%
4.130229167 1
0.1%
3.991354167 1
0.1%
3.943329689 1
0.1%
3.861979167 1
0.1%
3.850083333 1
0.1%
3.845543478 1
0.1%
3.808640177 1
0.1%
3.7930625 1
0.1%
3.787901884 1
0.1%

H
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct1166
Distinct (%)99.9%
Missing149
Missing (%)11.3%
Infinite0
Infinite (%)0.0%
Mean20.453067
Minimum-10.0435
Maximum50.88525
Zeros0
Zeros (%)0.0%
Negative22
Negative (%)1.7%
Memory size20.6 KiB

Quantile statistics

Minimum-10.0435
5-th percentile3.8511542
Q114.011062
median20.748042
Q326.827792
95-th percentile36.8353
Maximum50.88525
Range60.92875
Interquartile range (IQR)12.816729

Descriptive statistics

Standard deviation9.9005181
Coefficient of variation (CV)0.48406031
Kurtosis0.024025044
Mean20.453067
Median Absolute Deviation (MAD)6.4061667
Skewness0.00086155599
Sum23868.73
Variance98.020259
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
34.49279167 2
 
0.2%
29.44779167 1
 
0.1%
20.94841667 1
 
0.1%
16.74820833 1
 
0.1%
14.922875 1
 
0.1%
22.66304167 1
 
0.1%
14.98310417 1
 
0.1%
15.15332292 1
 
0.1%
15.088 1
 
0.1%
1.615625 1
 
0.1%
Other values (1156) 1156
87.8%
(Missing) 149
 
11.3%
ValueCountFrequency (%)
-10.0435 1
0.1%
-8.199125 1
0.1%
-7.135208333 1
0.1%
-5.6449375 1
0.1%
-4.7205 1
0.1%
-4.056958333 1
0.1%
-4.010416667 1
0.1%
-4.008666667 1
0.1%
-3.4003125 1
0.1%
-2.7279375 1
0.1%
ValueCountFrequency (%)
50.88525 1
0.1%
50.48754167 1
0.1%
49.71333333 1
0.1%
48.45241667 1
0.1%
47.81291667 1
0.1%
47.34979167 1
0.1%
46.23125 1
0.1%
45.51122917 1
0.1%
45.47733333 1
0.1%
44.93783333 1
0.1%

LE
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct1033
Distinct (%)99.9%
Missing282
Missing (%)21.4%
Infinite0
Infinite (%)0.0%
Mean88.35249
Minimum18.508917
Maximum147.66592
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum18.508917
5-th percentile48.360711
Q175.367203
median90.921615
Q3103.7501
95-th percentile120.39443
Maximum147.66592
Range129.157
Interquartile range (IQR)28.382893

Descriptive statistics

Standard deviation22.210276
Coefficient of variation (CV)0.25138257
Kurtosis0.20995495
Mean88.35249
Median Absolute Deviation (MAD)13.754786
Skewness-0.46292461
Sum91356.475
Variance493.29637
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
95.18020833 2
 
0.2%
92.926375 1
 
0.1%
71.83216667 1
 
0.1%
95.14283333 1
 
0.1%
80.27875 1
 
0.1%
106.5915833 1
 
0.1%
97.62210417 1
 
0.1%
95.21833333 1
 
0.1%
88.510375 1
 
0.1%
81.17516667 1
 
0.1%
Other values (1023) 1023
77.7%
(Missing) 282
 
21.4%
ValueCountFrequency (%)
18.50891667 1
0.1%
18.65333333 1
0.1%
19.42597917 1
0.1%
20.208375 1
0.1%
21.63791667 1
0.1%
23.053375 1
0.1%
23.3055 1
0.1%
23.50358333 1
0.1%
23.73033333 1
0.1%
24.22116667 1
0.1%
ValueCountFrequency (%)
147.6659167 1
0.1%
147.5625833 1
0.1%
147.0230417 1
0.1%
144.3867917 1
0.1%
140.8646875 1
0.1%
137.3425833 1
0.1%
137.225125 1
0.1%
136.7162708 1
0.1%
136.07525 1
0.1%
133.9537708 1
0.1%

rh
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct1054
Distinct (%)99.9%
Missing261
Missing (%)19.8%
Infinite0
Infinite (%)0.0%
Mean86.64286
Minimum68.235879
Maximum99.522379
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum68.235879
5-th percentile75.164077
Q182.191087
median87.2967
Q391.726765
95-th percentile95.770897
Maximum99.522379
Range31.2865
Interquartile range (IQR)9.5356771

Descriptive statistics

Standard deviation6.4050809
Coefficient of variation (CV)0.073925086
Kurtosis-0.54890632
Mean86.64286
Median Absolute Deviation (MAD)4.825175
Skewness-0.37453256
Sum91408.218
Variance41.025061
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
85.6635375 2
 
0.2%
86.01182083 1
 
0.1%
79.08537083 1
 
0.1%
80.8546625 1
 
0.1%
84.55933854 1
 
0.1%
86.01404583 1
 
0.1%
74.32185 1
 
0.1%
77.93953333 1
 
0.1%
89.02750417 1
 
0.1%
83.98682917 1
 
0.1%
Other values (1044) 1044
79.3%
(Missing) 261
 
19.8%
ValueCountFrequency (%)
68.23587917 1
0.1%
68.66025 1
0.1%
69.64278333 1
0.1%
69.88706458 1
0.1%
70.13134583 1
0.1%
70.14143333 1
0.1%
70.37562708 1
0.1%
70.61990833 1
0.1%
71.14267917 1
0.1%
71.3171125 1
0.1%
ValueCountFrequency (%)
99.52237917 1
0.1%
99.44590417 1
0.1%
99.1845625 1
0.1%
99.08865833 1
0.1%
99.02960833 1
0.1%
98.3446125 1
0.1%
98.1899 1
0.1%
97.99869583 1
0.1%
97.9927625 1
0.1%
97.98884348 1
0.1%

h2o
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct1080
Distinct (%)99.9%
Missing235
Missing (%)17.9%
Infinite0
Infinite (%)0.0%
Mean16.180113
Minimum13.6365
Maximum19.105273
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum13.6365
5-th percentile14.605396
Q115.546667
median16.099458
Q316.747583
95-th percentile17.947583
Maximum19.105273
Range5.4687727
Interquartile range (IQR)1.2009167

Descriptive statistics

Standard deviation0.9722772
Coefficient of variation (CV)0.060090877
Kurtosis0.27338126
Mean16.180113
Median Absolute Deviation (MAD)0.59841667
Skewness0.37127232
Sum17490.702
Variance0.94532295
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
14.45216667 2
 
0.2%
15.95204167 1
 
0.1%
15.61061458 1
 
0.1%
16.60195833 1
 
0.1%
16.06758333 1
 
0.1%
16.22908333 1
 
0.1%
17.55404167 1
 
0.1%
16.23620833 1
 
0.1%
17.71679167 1
 
0.1%
18.60675 1
 
0.1%
Other values (1070) 1070
81.3%
(Missing) 235
 
17.9%
ValueCountFrequency (%)
13.6365 1
0.1%
13.76983333 1
0.1%
13.78266667 1
0.1%
13.81761364 1
0.1%
13.8420625 1
0.1%
14.01375 1
0.1%
14.0215625 1
0.1%
14.04940909 1
0.1%
14.08720833 1
0.1%
14.115625 1
0.1%
ValueCountFrequency (%)
19.10527273 1
0.1%
19.04875 1
0.1%
19.01258333 1
0.1%
18.952125 1
0.1%
18.94704545 1
0.1%
18.94041667 1
0.1%
18.9200625 1
0.1%
18.86779167 1
0.1%
18.83777083 1
0.1%
18.83508333 1
0.1%

Fh2o
Real number (ℝ)

Distinct1111
Distinct (%)99.6%
Missing201
Missing (%)15.3%
Infinite0
Infinite (%)0.0%
Mean-951.60529
Minimum-9582.0808
Maximum3.9388333
Zeros0
Zeros (%)0.0%
Negative484
Negative (%)36.8%
Memory size20.6 KiB

Quantile statistics

Minimum-9582.0808
5-th percentile-5415.5388
Q1-831.81694
median1.3978333
Q32.1255625
95-th percentile2.6180375
Maximum3.9388333
Range9586.0196
Interquartile range (IQR)833.9425

Descriptive statistics

Standard deviation1798.3655
Coefficient of variation (CV)-1.8898229
Kurtosis5.2574889
Mean-951.60529
Median Absolute Deviation (MAD)1.1432083
Skewness-2.3813228
Sum-1061039.9
Variance3234118.5
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2.578416667 2
 
0.2%
2.083333333 2
 
0.2%
2.165625 2
 
0.2%
2.292958333 2
 
0.2%
2.43225 1
 
0.1%
-2915.343667 1
 
0.1%
1.828333333 1
 
0.1%
2.17 1
 
0.1%
2.372041667 1
 
0.1%
2.02 1
 
0.1%
Other values (1101) 1101
83.7%
(Missing) 201
 
15.3%
ValueCountFrequency (%)
-9582.080792 1
0.1%
-9165.753542 1
0.1%
-9165.694583 1
0.1%
-9164.931417 1
0.1%
-8749.115167 1
0.1%
-8332.511042 1
0.1%
-8332.496542 1
0.1%
-8332.485583 1
0.1%
-8332.445292 1
0.1%
-8332.389792 1
0.1%
ValueCountFrequency (%)
3.938833333 1
0.1%
3.2915 1
0.1%
3.133041667 1
0.1%
3.128375 1
0.1%
3.041166667 1
0.1%
3.019166667 1
0.1%
3.013791667 1
0.1%
3.008416667 1
0.1%
2.99075 1
0.1%
2.953708333 1
0.1%

ee
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct1036
Distinct (%)99.9%
Missing279
Missing (%)21.2%
Infinite0
Infinite (%)0.0%
Mean2.8651696
Minimum2.5157528
Maximum3.1905864
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum2.5157528
5-th percentile2.6459188
Q12.7845962
median2.8667655
Q32.9447157
95-th percentile3.0674762
Maximum3.1905864
Range0.67483365
Interquartile range (IQR)0.16011948

Descriptive statistics

Standard deviation0.12202887
Coefficient of variation (CV)0.042590452
Kurtosis-0.08827951
Mean2.8651696
Median Absolute Deviation (MAD)0.08027149
Skewness-0.10253991
Sum2971.1809
Variance0.014891045
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2.63437081 2
 
0.2%
3.084328941 1
 
0.1%
2.556237044 1
 
0.1%
2.8474846 1
 
0.1%
2.832305478 1
 
0.1%
2.855036252 1
 
0.1%
2.836559628 1
 
0.1%
2.602266749 1
 
0.1%
2.775507246 1
 
0.1%
3.10752355 1
 
0.1%
Other values (1026) 1026
78.0%
(Missing) 279
 
21.2%
ValueCountFrequency (%)
2.515752762 1
0.1%
2.517931475 1
0.1%
2.532627264 1
0.1%
2.538286193 1
0.1%
2.549773285 1
0.1%
2.553417028 1
0.1%
2.556237044 1
0.1%
2.567478213 1
0.1%
2.568345597 1
0.1%
2.571580498 1
0.1%
ValueCountFrequency (%)
3.190586415 1
0.1%
3.172285719 1
0.1%
3.165801447 1
0.1%
3.165782546 1
0.1%
3.161710058 1
0.1%
3.153565011 1
0.1%
3.151444992 1
0.1%
3.151041216 1
0.1%
3.144668528 1
0.1%
3.136575876 1
0.1%

ees
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct1294
Distinct (%)99.8%
Missing19
Missing (%)1.4%
Infinite0
Infinite (%)0.0%
Mean3.3767037
Minimum2.6620042
Maximum4.0224292
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum2.6620042
5-th percentile2.9759675
Q13.2017182
median3.3866333
Q33.560625
95-th percentile3.7575375
Maximum4.0224292
Range1.360425
Interquartile range (IQR)0.35890682

Descriptive statistics

Standard deviation0.24235107
Coefficient of variation (CV)0.071771493
Kurtosis-0.51508873
Mean3.3767037
Median Absolute Deviation (MAD)0.17984167
Skewness-0.15311369
Sum4379.5847
Variance0.058734039
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3.535325 2
 
0.2%
3.12005 2
 
0.2%
3.620170833 2
 
0.2%
3.324495833 1
 
0.1%
3.369266667 1
 
0.1%
3.395016667 1
 
0.1%
3.660979167 1
 
0.1%
3.168266667 1
 
0.1%
2.9361875 1
 
0.1%
3.551483333 1
 
0.1%
Other values (1284) 1284
97.6%
(Missing) 19
 
1.4%
ValueCountFrequency (%)
2.662004167 1
0.1%
2.7034125 1
0.1%
2.743766667 1
0.1%
2.7546875 1
0.1%
2.769091667 1
0.1%
2.775491667 1
0.1%
2.776045833 1
0.1%
2.778 1
0.1%
2.787675 1
0.1%
2.795795833 1
0.1%
ValueCountFrequency (%)
4.022429167 1
0.1%
3.929691667 1
0.1%
3.928616667 1
0.1%
3.924170833 1
0.1%
3.9185375 1
0.1%
3.913617391 1
0.1%
3.907641667 1
0.1%
3.899854167 1
0.1%
3.886172727 1
0.1%
3.874625 1
0.1%

So
Real number (ℝ)

Distinct718
Distinct (%)54.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean415.75813
Minimum372.2964
Maximum441.29846
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum372.2964
5-th percentile373.40442
Q1396.1086
median426.02822
Q3434.2253
95-th percentile440.41383
Maximum441.29846
Range69.002057
Interquartile range (IQR)38.116701

Descriptive statistics

Standard deviation22.673836
Coefficient of variation (CV)0.054536122
Kurtosis-0.96101712
Mean415.75813
Median Absolute Deviation (MAD)10.756163
Skewness-0.73878008
Sum547137.7
Variance514.10284
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
425.3425789 4
 
0.3%
426.6909625 3
 
0.2%
426.333287 3
 
0.2%
411.2465478 2
 
0.2%
429.7734646 2
 
0.2%
436.2612064 2
 
0.2%
441.1804659 2
 
0.2%
407.2666137 2
 
0.2%
372.626972 2
 
0.2%
428.7377697 2
 
0.2%
Other values (708) 1292
98.2%
ValueCountFrequency (%)
372.2963989 2
0.2%
372.2963989 1
0.1%
372.3051404 2
0.2%
372.3051404 2
0.2%
372.3163363 2
0.2%
372.3163363 2
0.2%
372.3425868 2
0.2%
372.3425868 2
0.2%
372.3648969 2
0.2%
372.3648969 2
0.2%
ValueCountFrequency (%)
441.2984556 2
0.2%
441.2984556 2
0.2%
441.2969526 1
0.1%
441.2969526 2
0.2%
441.2807291 2
0.2%
441.2807291 1
0.1%
441.2765501 2
0.2%
441.2765501 2
0.2%
441.2434632 2
0.2%
441.2434632 1
0.1%

NEE
Real number (ℝ)

Distinct1147
Distinct (%)87.4%
Missing3
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean-0.040131378
Minimum-3.9400529
Maximum4.1293851
Zeros0
Zeros (%)0.0%
Negative653
Negative (%)49.6%
Memory size20.6 KiB

Quantile statistics

Minimum-3.9400529
5-th percentile-2.0799727
Q1-0.75554265
median0.0093635343
Q30.64030709
95-th percentile1.9391796
Maximum4.1293851
Range8.0694379
Interquartile range (IQR)1.3958497

Descriptive statistics

Standard deviation1.219423
Coefficient of variation (CV)-30.385775
Kurtosis0.84715872
Mean-0.040131378
Median Absolute Deviation (MAD)0.70975227
Skewness0.038109062
Sum-52.692499
Variance1.4869925
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.3633180916 23
 
1.7%
0.9027372678 20
 
1.5%
0.09247122752 19
 
1.4%
-0.3369108543 15
 
1.1%
0.1379147689 14
 
1.1%
0.5448720383 14
 
1.1%
-1.220333716 14
 
1.1%
0.5925394284 13
 
1.0%
-0.2995503442 11
 
0.8%
0.3366597182 8
 
0.6%
Other values (1137) 1162
88.3%
ValueCountFrequency (%)
-3.940052858 1
0.1%
-3.871265441 1
0.1%
-3.846119369 1
0.1%
-3.680795139 1
0.1%
-3.630852229 1
0.1%
-3.611621635 1
0.1%
-3.608726729 1
0.1%
-3.530271902 1
0.1%
-3.492290657 1
0.1%
-3.489773019 1
0.1%
ValueCountFrequency (%)
4.129385064 1
0.1%
3.997500447 1
0.1%
3.852201303 1
0.1%
3.827729395 1
0.1%
3.61461304 1
0.1%
3.603123643 1
0.1%
3.526028597 1
0.1%
3.449391597 1
0.1%
3.4257663 1
0.1%
3.396854961 1
0.1%

prec
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct167
Distinct (%)12.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.3270714
Minimum0
Maximum128.27
Zeros710
Zeros (%)54.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q33.6195
95-th percentile21.9075
Maximum128.27
Range128.27
Interquartile range (IQR)3.6195

Descriptive statistics

Standard deviation10.619895
Coefficient of variation (CV)2.4542917
Kurtosis35.434545
Mean4.3270714
Median Absolute Deviation (MAD)0
Skewness5.009082
Sum5694.426
Variance112.78218
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 710
54.0%
0.254 72
 
5.5%
0.508 29
 
2.2%
0.762 27
 
2.1%
3.048 23
 
1.7%
1.524 20
 
1.5%
1.016 19
 
1.4%
1.27 19
 
1.4%
2.54 13
 
1.0%
2.032 12
 
0.9%
Other values (157) 372
28.3%
ValueCountFrequency (%)
0 710
54.0%
0.254 72
 
5.5%
0.508 29
 
2.2%
0.762 27
 
2.1%
1.016 19
 
1.4%
1.27 19
 
1.4%
1.524 20
 
1.5%
1.778 11
 
0.8%
2.032 12
 
0.9%
2.286 9
 
0.7%
ValueCountFrequency (%)
128.27 1
0.1%
96.012 1
0.1%
94.234 1
0.1%
93.98 1
0.1%
83.058 1
0.1%
81.534 1
0.1%
76.2 1
0.1%
62.992 1
0.1%
61.468 1
0.1%
59.944 1
0.1%

aod
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct1301
Distinct (%)100.0%
Missing15
Missing (%)1.1%
Infinite0
Infinite (%)0.0%
Mean0.25924245
Minimum0.017746524
Maximum1.7788357
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum0.017746524
5-th percentile0.070878531
Q10.1431835
median0.21806244
Q30.29809703
95-th percentile0.6216788
Maximum1.7788357
Range1.7610892
Interquartile range (IQR)0.15491353

Descriptive statistics

Standard deviation0.19419633
Coefficient of variation (CV)0.74909154
Kurtosis10.73203
Mean0.25924245
Median Absolute Deviation (MAD)0.077814481
Skewness2.7196885
Sum337.27443
Variance0.037712214
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.1237706365 1
 
0.1%
0.4489211706 1
 
0.1%
0.2393149166 1
 
0.1%
0.2226981888 1
 
0.1%
0.04571464717 1
 
0.1%
0.1305982694 1
 
0.1%
0.1142352307 1
 
0.1%
0.168023493 1
 
0.1%
0.2316856133 1
 
0.1%
0.1446391973 1
 
0.1%
Other values (1291) 1291
98.1%
(Missing) 15
 
1.1%
ValueCountFrequency (%)
0.01774652385 1
0.1%
0.02708058325 1
0.1%
0.0273432066 1
0.1%
0.0298522179 1
0.1%
0.03170419667 1
0.1%
0.03230624799 1
0.1%
0.03274396525 1
0.1%
0.03428211913 1
0.1%
0.03600417644 1
0.1%
0.0390806554 1
0.1%
ValueCountFrequency (%)
1.778835739 1
0.1%
1.488781834 1
0.1%
1.453398735 1
0.1%
1.322331482 1
0.1%
1.296995674 1
0.1%
1.29104853 1
0.1%
1.233546347 1
0.1%
1.217994241 1
0.1%
1.212086453 1
0.1%
1.203660954 1
0.1%

LAI
Real number (ℝ)

Distinct1315
Distinct (%)100.0%
Missing1
Missing (%)0.1%
Infinite0
Infinite (%)0.0%
Mean0.81930432
Minimum0.47481937
Maximum1.413536
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size20.6 KiB

Quantile statistics

Minimum0.47481937
5-th percentile0.56443677
Q10.64203582
median0.73142477
Q31.0162372
95-th percentile1.2145133
Maximum1.413536
Range0.93871663
Interquartile range (IQR)0.37420135

Descriptive statistics

Standard deviation0.21981168
Coefficient of variation (CV)0.26829064
Kurtosis-0.9112733
Mean0.81930432
Median Absolute Deviation (MAD)0.12714711
Skewness0.64348886
Sum1077.3852
Variance0.048317175
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.006993895 1
 
0.1%
1.196562107 1
 
0.1%
0.6023442012 1
 
0.1%
1.34419961 1
 
0.1%
0.6747174045 1
 
0.1%
0.9198705992 1
 
0.1%
0.7015911621 1
 
0.1%
0.5437385923 1
 
0.1%
0.9114065374 1
 
0.1%
1.027621383 1
 
0.1%
Other values (1305) 1305
99.2%
ValueCountFrequency (%)
0.4748193738 1
0.1%
0.4842411531 1
0.1%
0.4961232035 1
0.1%
0.4992068136 1
0.1%
0.501043482 1
0.1%
0.5057531676 1
0.1%
0.5064695356 1
0.1%
0.5095952718 1
0.1%
0.512410631 1
0.1%
0.5134943911 1
0.1%
ValueCountFrequency (%)
1.413536004 1
0.1%
1.392756543 1
0.1%
1.366300843 1
0.1%
1.362119223 1
0.1%
1.34419961 1
0.1%
1.33032874 1
0.1%
1.304147546 1
0.1%
1.303625604 1
0.1%
1.294660712 1
0.1%
1.291776066 1
0.1%

Interactions

Correlations

Auto

The auto setting is an interpretable pairwise column metric of the following mapping:
  • Variable_type-Variable_type : Method, Range
  • Categorical-Categorical : Cramer's V, [0,1]
  • Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
  • Numerical-Numerical : Spearman's ρ, [-1,1]
The number of bins used in the discretization for the Numerical-Categorical column pair can be changed using config.correlations["auto"].n_bins. The number of bins affects the granularity of the association you wish to measure.

This configuration uses the recommended metric for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

DatetapressparRnwsHLErhh2oFh2oeeeesSoNEEprecaodLAI
8552004-05-0425.16041797.579804297.215958130.5687502.29996218.595667NaN93.182042NaNNaN3.0843293.324496400.7946150.3633183.0480.1237711.006994
3812003-01-1626.27141797.620146368.249708135.5604173.30568221.28625085.54475075.80029615.5737921.9507082.6278853.523296430.751171-0.0646320.0000.2374330.764556
7212003-12-2224.95052297.433821341.673417130.5947923.0286679.99489680.385083NaN16.083375-415.064875NaN3.377138425.4454101.4078081.5240.2391290.617596
5772003-07-3125.93870897.722537389.51358392.5875003.06645424.866833106.40062582.17885415.8611252.4267082.8449553.498562390.5181070.6468330.0000.2041371.211760
352002-02-0426.08130497.634412535.270583NaN3.30560425.365679NaN78.79746117.932597-2914.4263752.7000323.461342437.2616332.3013490.0000.0957730.621415
3012002-10-2825.77929297.329392455.454333177.8229173.78790220.660583103.77675077.51659214.953458-1247.8732502.7986083.676725435.813511-1.6835900.0000.4367470.519126
6892003-11-2024.84037597.306183308.247042117.7125003.05625017.05229291.717667NaN17.8721672.090417NaN3.383683430.049489-2.9656070.0000.2841840.771282
10192004-10-1527.22727197.359775442.881458170.8614582.98972930.430875103.92683083.72288515.789225-3749.1675003.1104933.793438436.835230-0.5527390.0000.2755500.668496
12522005-06-0526.08429297.281600381.474500NaN3.17841722.97062561.23518695.25672515.967602-4581.957000NaN3.594292376.7531410.9353560.0000.1011041.074035
8612004-05-1024.56404297.655767194.12937583.3895831.7093546.155958NaN95.899529NaNNaN3.0523233.186679395.1896760.36331822.6060.1698180.779472
DatetapressparRnwsHLErhh2oFh2oeeeesSoNEEprecaodLAI
3472002-12-1326.14029297.430067408.938083161.3572923.35259016.71570896.18262583.33225017.178958-414.6118752.8806133.509688425.5337511.2294550.0000.2592660.596157
5512003-07-0525.19212597.583304368.924125151.1520832.13537527.78862599.85868883.90431315.930021-414.6108752.7402353.302467374.3917880.5925390.2540.0785701.153500
5402003-06-2423.83616797.815112298.431583121.4395832.62233321.135958NaN91.720779NaNNaN2.7818233.051175372.3163360.3366606.0960.1655951.145905
7272003-12-2823.85275097.199588324.613333127.9437503.3234587.58187594.582417NaN17.0340422.154500NaN3.139929426.028221-0.7057847.3660.2782960.582518
5162003-05-3124.15775097.755500235.60745897.4145832.8469957.32116761.41866793.53810416.8112501.3978332.9113073.118671379.4968321.36428523.8760.1688251.028997
9292004-07-1723.85595897.786979186.99612571.1583332.21741710.746208NaN94.864343NaNNaN2.9306013.075812380.8349921.6406750.0000.1351341.161527
10372004-11-0225.61062597.273108198.415042129.0406253.24462518.716583105.88093884.16335615.073833NaN2.9120373.593588434.615135-0.3455220.0000.2766940.597915
12372005-05-2122.30220897.423979331.865042NaN1.5516254.023630NaN96.249808NaN-6665.6175832.7588102.868496386.5669500.33244233.0200.2155491.023359
2062002-07-2525.79870897.815858439.461500158.7750002.83733342.82904287.11404282.89736716.6600001.9863332.7972323.406321385.738409-0.0444280.2540.1139461.031625
9852004-09-1125.24225097.529392331.482208141.3145832.58862519.23704294.12462589.17731315.8867922.1463752.9548453.353721425.905442-0.8937455.0801.7788360.911696